﻿CREATE TABLE [dbo].[onco_Protocoale] (
    [Durata]               FLOAT (53)     NULL,
    [NumarDeZile]          FLOAT (53)     NULL,
    [Denumire]             NVARCHAR (255) NULL,
    [ZileCiclu]            FLOAT (53)     NULL,
    [Punctaj]              FLOAT (53)     NULL,
    [Observatii]           NVARCHAR (255) NULL,
    [NumarDeZileTratament] FLOAT (53)     NULL,
    [CIM 10]               NVARCHAR (255) NULL,
    [IDProtocol]           SMALLINT       IDENTITY (1, 1) NOT NULL,
    [IDDurataPerfuzie]     SMALLINT       CONSTRAINT [DF_Protocoale2_IDDurataPerfuzie] DEFAULT ((4)) NOT NULL,
    [IDProcedura]          INT            NULL,
    [Activ]                BIT            DEFAULT ((1)) NOT NULL,
    CONSTRAINT [PK_Protocoale2] PRIMARY KEY CLUSTERED ([IDProtocol] ASC),
    CONSTRAINT [FK_onco_Protocoale_onco_DurataPerfuzie] FOREIGN KEY ([IDDurataPerfuzie]) REFERENCES [dbo].[onco_DurataPerfuzie] ([IDDurata]),
    CONSTRAINT [FK_onco_Protocoale_onco_ListaProceduri] FOREIGN KEY ([IDProcedura]) REFERENCES [dbo].[onco_ListaProceduri] ([IdProcedura]),
    CONSTRAINT [IX_onco_Protocoale] UNIQUE NONCLUSTERED ([Denumire] ASC)
);

